Midwest Airlines Employee Data and Analysis
Midwest Airlines
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008
Traffic Indicies  
Stage Length in Miles (for SLA purposes)                691               731               707               737               770               778               780               782               802               879               879               885               944               946
Seats Per Departure (for SDA purposes)                79                77                80                82                86                88                91                93               100               109               106               104               104               105
Price Per Gallon of Fuel  $          0.54  $          0.65  $          0.62  $          0.44  $          0.50  $          0.89  $          0.82  $          0.71  $          0.88  $          1.16  $          1.71  $          1.99  $          1.84  $          3.16
Airborne Hours / Block Hours 86% 86% 86% 86% 84% 85% 88% 89% 88% 87% 87% 87% 88% 81%
Outsourcing Indicies  
Maintenance $'s Outsourced 34.1% 40.7% 38.7% 42.7% 55.3% 44.5% 37.2% 28.7% 21.1% 31.2% 53.1% 55.1% 69.7% 39.4%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 12.0% 10.5% 8.7% 8.1% 7.2% 8.6% 8.7% 9.1% 11.0% 10.3% 10.9% 12.0% 12.8% 8.6%
Transport Related Expense (000)  $           734  $           118  $           108  $             83  $           139  $           120  $           158  $           209  $           405  $           281  $           342  $           894  $      62,496  $     181,186
Productivity Measures (unadjusted)  
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)              66.6              51.2              54.7                 -                47.9              47.7              54.5              45.5              46.6              48.2              52.2              56.2              55.3              43.7
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)              34.0              32.7              36.6                 -                38.0              32.1              41.4              38.8              41.2              44.5              47.2              50.2              48.2              41.5
Maintenance              34.2              36.3              33.3                 -                23.2              15.8              16.3              16.8              24.1              22.6              47.5              53.6              52.4              41.1
Passenger, Cargo and Aircraft Handling               8.7               9.0               8.2                 -                 9.3              11.7              11.4              11.0               9.4               8.8              11.2              15.3               8.5               9.9
Other              23.2              24.1              21.9                 -                25.5              13.6              15.6              15.7              22.5              26.7              37.0              34.7              31.1              27.2
Total               3.7               3.7               3.5                 -                 3.4               3.1               3.3               3.2               3.4               3.4               4.4               5.2               4.0               3.8
ASMs Per Employee (000)
Pilots & Co-Pilots       11,625.4         8,881.4         9,505.6                 -           8,881.0         9,031.4       10,886.3         9,428.5       10,452.6       11,899.1       12,799.0       13,400.1       13,391.7       10,286.3
Flight Attendants         7,511.0         7,401.1         7,977.9                 -           8,227.6         6,885.7         9,133.4         8,664.0         9,241.6       10,124.1       10,858.8       11,564.5       11,186.9         9,353.3
Maintenance       11,929.3       12,568.0       11,574.2                 -           8,602.7         5,992.6         6,518.6         6,968.9       10,787.4       11,173.6       23,252.6       25,582.0       25,363.9       19,365.3
Passenger, Cargo and Aircraft Handling         3,042.0         3,117.5         2,838.4                 -           3,435.2         4,440.2         4,547.4         4,573.0         4,227.7         4,332.1         5,476.3         7,298.6         4,104.4         4,645.1
Other         8,111.9         8,361.1         7,598.0                 -           9,436.0         5,150.4         6,229.7         6,502.4       10,070.6       13,183.2       18,127.5       16,553.1       15,038.2       12,810.0
Total         1,302.8         1,266.4         1,203.6                 -           1,245.7         1,155.1         1,321.3         1,315.4         1,545.0         1,690.5         2,157.0         2,467.2         1,919.1         1,774.1
Employees Per Aircraft
Pilots & Co-Pilots (Crews)               4.0               5.6               5.1                 -                 5.7               5.4               4.3               5.0               4.8               5.4               5.4               5.3               5.5               6.4
Flight Attendants (Crews)               7.8               8.7               7.7                 -                 7.2               8.0               5.7               5.8               5.5               5.9               6.0               5.9               6.4               6.7
Maintenance (Inhouse)               7.7               7.9               8.4                 -                11.8              16.3              14.4              13.5               9.4              11.5               6.0               5.5               5.9               6.8
Passenger, Cargo and Aircraft Handling (Inhouse)              30.3              31.8              34.3                 -                29.5              22.0              20.7              20.5              24.0              29.7              25.4              19.4              36.2              28.3
Other (Inhouse)              11.4              11.8              12.8                 -                10.7              19.0              15.1              14.4              10.1               9.8               7.7               8.6               9.9              10.3
Total              70.7              78.2              80.9                 -                81.3              84.6              71.2              71.3              65.6              76.1              64.4              57.4              77.4              74.0
Passengers Per Employee
Pilots & Co-Pilots            9,060            6,738            7,130                 -              6,495            6,259            7,416            6,440            7,347            7,715            9,256          10,302            9,854            7,496
Flight Attendants            5,854            5,615            5,984                 -              6,017            4,772            6,222            5,918            6,496            6,564            7,853            8,891            8,232            6,816
Maintenance            9,297            9,534            8,682                 -              6,291            4,153            4,441            4,760            7,582            7,245          16,815          19,667          18,664          14,111
Passenger, Cargo and Aircraft Handling            2,371            2,365            2,129                 -              2,512            3,077            3,098            3,124            2,972            2,809            3,960            5,611            3,020            3,385
Other            6,322            6,343            5,699                 -              6,901            3,570            4,244            4,442            7,079            8,548          13,109          12,726          11,066            9,335
Total            1,015               961               903                 -                 911               801               900               899            1,086            1,096            1,560            1,897            1,412            1,293
Productivity Measures Revenue  
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $     1,306.8  $     1,063.0  $     1,160.8  $             -    $     1,065.6  $     1,077.6  $     1,168.7  $        898.5  $        896.9  $        906.4  $     1,073.0  $     1,301.1  $     1,283.4  $     1,040.6
Flight Attendants  $        844.3  $        885.8  $        974.2  $             -    $        987.2  $        821.6  $        980.5  $        825.7  $        793.0  $        771.2  $        910.3  $     1,122.9  $     1,072.1  $        946.2
Maintenance  $     1,341.0  $     1,504.2  $     1,413.4  $             -    $     1,032.2  $        715.0  $        699.8  $        664.1  $        925.7  $        851.1  $     1,949.3  $     2,483.9  $     2,430.7  $     1,959.1
Passenger, Cargo and Aircraft Handling  $        341.9  $        373.1  $        346.6  $             -    $        412.2  $        529.8  $        488.2  $        435.8  $        362.8  $        330.0  $        459.1  $        708.7  $        393.3  $        469.9
Other  $        911.8  $     1,000.7  $        927.8  $             -    $     1,132.1  $        614.5  $        668.8  $        619.7  $        864.2  $     1,004.2  $     1,519.7  $     1,607.3  $     1,441.2  $     1,295.9
Total  $        146.4  $        151.6  $        147.0  $             -    $        149.5  $        137.8  $        141.8  $        125.4  $        132.6  $        128.8  $        180.8  $        239.6  $        183.9  $        179.5
Salary and Benefits  
Average Salary
Management and All Other  $      36,836  $      50,755  $      49,437  $             -    $      46,433  $      30,430  $      38,052  $      36,822  $      48,982  $      58,620  $      60,809  $      60,165  $      59,500  $      63,296
Pilots & Co-Pilots  $      85,197  $      72,677  $      83,059  $             -    $      74,548  $      94,373  $     125,002  $     104,213  $     115,512  $     107,474  $     101,895  $      93,052  $      88,785  $      85,591
Flight Attendants  $      25,032  $      25,957  $      29,436  $             -    $      30,956  $      27,805  $      38,454  $      34,681  $      32,311  $      28,869  $      31,871  $      33,080  $      30,774  $      28,507
Maintenance  $      33,084  $      29,060  $      35,254  $             -    $      28,831  $      26,303  $      40,428  $      44,871  $      55,650  $      46,262  $      55,026  $      46,521  $      38,807  $      30,813
Passenger, Cargo and Aircraft Handling  $      23,557  $      25,474  $      25,070  $             -    $      29,397  $      41,135  $      36,331  $      33,604  $      28,071  $      24,130  $      26,229  $      31,106  $      17,964  $      22,717
Total  $      34,111  $      37,182  $      38,870  $             -    $      39,307  $      40,157  $      48,785  $      46,493  $      49,342  $      45,264  $      47,828  $      49,303  $      37,782  $      42,068
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $      12,480  $      11,511  $      14,452  $             -    $      12,620  $      17,888  $      25,024  $      20,704  $      24,688  $      24,966  $      21,988  $      16,958  $      17,769  $      18,840
All Others  $        3,076  $        4,166  $        3,964  $             -    $        7,180  $        7,992  $      10,496  $        9,265  $      10,047  $        9,785  $        9,791  $      13,256  $      10,006  $        9,521
Total  $        4,130  $        5,214  $        5,292  $             -    $        7,943  $        9,258  $      12,259  $      10,861  $      12,211  $      11,942  $      11,847  $      13,938  $      11,119  $      11,129
Personnel
Pilots & Co-Pilots  $        3,438  $        3,757  $        4,288  $             -    $        4,338  $        4,852  $        7,064  $        5,100  $        4,297  $        4,069  $        5,470  $        8,249  $        8,863  $        6,923
Flight Attendents  $        8,717  $      11,650  $      11,764  $             -    $      10,949  $        9,402  $      12,066  $      10,549  $        9,765  $        8,775  $        7,310  $        8,765  $        9,688  $        7,916
Payroll Taxes
Pilots & Co-Pilots  $        8,692  $        6,241  $        5,910  $             -    $        6,778  $        7,463  $        9,018  $        8,161  $        9,020  $        8,532  $        8,426  $        8,597  $        8,338  $        8,004
All Others  $        2,610  $        2,539  $        2,501  $             -    $        1,375  $              0  $             (0)  $            (93)  $             -    $             -    $             -    $              5  $             (0)  $             (0)
Raw Data  
Number of Months 12 12 12 12 12 12 12 12 12 12 12 12 12 12
Number of Days 365 366 365 365 365 366 365 365 365 366 365 365 365 365
P10- Employee Count Data  
Sum of General Management                23                44                67                 167                75                79                73                45                46                56                39                41                60
Sum of Pilots and Co-Pilots               157               225               235                 340               353               297               340               290               308               347               378               411               401
Sum of Other Flight Personnel                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Passenger and General Services               243               270               280                 367               463               354               370               328               362               409               438               492               441
Sum of Maintenance               153               159               193                 351               532               496               460               281               328               191               198               217               213
Sum of AC Handling 1                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Aircraft Handling               184                66                77                 212                  8                47                77                82                83                36                32                52                31
Sum of Aircraft Control                22                20                19                  47                44                38                40                35                36                41                43                57                 -  
Sum of Passenger Handling               372               533               663                 585               525               590               551               570               698               698               593            1,201               833
Sum of Cargo Handling                22                22                28                  35               141                36                33                30                29                36                26                31                24
Sum of Trainees and Instructors                17                22                25                  15                55                42                34                37                37                22                45                46                27
Sum of Stats                95                96               113                 125               110                85                90                86                74                65                86               106                92
Sum of Traffic Solicitors                33                30                34                  42               106                94                94                51                46                33                31                31                30
Sum of Other                80                91               122                 138               348               298               275               127               121               125               144               183               173
Sum of Transport Related                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Total            1,401            1,578            1,856            2,424            2,760            2,447            2,437            1,962            2,168            2,059            2,053            2,868            2,325
P6- Objective Grouping Operating Expense Data  
Sum of Salaries-General Management Personnel (000)  $        3,837  $        7,359  $        9,851  $      15,260  $      11,913  $        9,069  $        9,911  $        9,236  $        7,587  $      10,147  $        9,285  $        9,496  $        9,336  $        8,565
Sum of Salaries-Flight Personnel (000)  $      19,459  $      23,361  $      27,761  $      31,271  $      36,707  $      46,187  $      50,738  $      48,264  $      44,097  $      43,553  $      48,393  $      49,663  $      51,632  $      46,894
Sum of Salaries-Maintenance Labor (000)  $        5,062  $        4,621  $        6,804  $        8,071  $      10,120  $      13,993  $      20,053  $      20,641  $      15,638  $      15,174  $      10,510  $        9,211  $        8,421  $        6,563
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)  $      14,134  $      16,329  $      19,730  $      23,099  $      25,840  $      29,535  $      25,832  $      23,556  $      20,127  $      20,414  $      21,272  $      21,587  $      24,090  $      20,173
Sum of Salaries-Other Personnel (000)  $        5,299  $        7,005  $        7,995  $        9,164  $      10,700  $      12,050  $      12,844  $      11,606  $        9,361  $        8,846  $        9,019  $      11,261  $      14,881  $      15,614
Sum of Salaries-Total (000)  $      47,790  $      58,674  $      72,142  $      86,865  $      95,279  $     110,834  $     119,377  $     113,303  $      96,809  $      98,133  $      98,478  $     101,218  $     108,359  $      97,809
Sum of Related Fringe Benefits-Personnel Expense (000)  $        2,658  $        3,991  $        4,301  $        4,725  $        5,493  $        6,066  $        6,369  $        5,637  $        4,449  $        4,430  $        4,888  $        6,957  $        8,409  $        6,267
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $        5,786  $        8,227  $        9,822  $      11,392  $      19,253  $      25,552  $      29,998  $      26,468  $      23,958  $      25,890  $      24,392  $      28,614  $      31,888  $      25,874
Sum of Related Fringe Benefits-Payroll Taxes (000)  $        4,611  $        4,839  $        5,443  $        7,570  $        5,171  $        2,635  $        2,678  $        2,579  $        2,616  $        2,628  $        2,924  $        3,258  $        3,427  $        3,210
Sum of Related Fringe Benefits-Total (000)  $      13,055  $      17,057  $      19,566  $      23,687  $      29,917  $      34,253  $      39,045  $      34,684  $      31,023  $      32,948  $      32,204  $      38,829  $      43,724  $      32,973
Sum of Total Salaries And Related Fringe Benefits (000)  $      60,845  $      75,730  $      91,708  $     110,552  $     125,197  $     145,086  $     158,423  $     147,987  $     127,832  $     131,081  $     130,682  $     140,047  $     152,083  $     130,782
Sum of Services Purchased-Advertising And Other Promotions (000)  $        7,414  $        6,586  $        6,495  $        6,716  $        7,500  $        9,052  $        8,872  $        9,657  $        8,924  $      10,531  $      10,985  $      11,382  $      11,129  $      10,786
Sum of Services Purchased-Communication (000)  $        2,070  $        2,252  $        3,045  $        3,460  $        3,704  $        3,624  $        3,800  $        3,217  $        2,982  $        3,050  $        3,988  $        4,215  $        4,389  $        4,400
Sum of Services Purchased-Insurance (000)  $        2,386  $        2,865  $        2,799  $        2,263  $        2,090  $        2,082  $        2,638  $        6,561  $        4,794  $        4,818  $        4,965  $        5,555  $        4,748  $        2,618
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $        6,431  $        9,084  $      12,142  $      18,399  $      27,207  $      25,028  $      19,977  $      10,225  $        5,645  $      10,464  $      18,743  $      18,065  $      29,637  $      12,800
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $      16,520  $      21,956  $      27,665  $      26,500  $      26,844  $      22,321  $      20,150  $      15,327  $        9,375  $        8,660  $      11,718  $      15,882  $      18,161  $      15,619
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Services Purchased-Other Services (000)  $      20,573  $      21,303  $      20,208  $      21,536  $      22,166  $      29,080  $      30,713  $      28,866  $      30,526  $      30,694  $      36,359  $      45,276  $      61,977  $      74,740
Sum of Services Purchased-Total (000)  $      55,395  $      64,045  $      72,354  $      78,874  $      89,512  $      91,186  $      86,150  $      73,852  $      62,247  $      68,217  $      86,758  $     100,375  $     130,041  $     120,963
Sum of Transport Related Expense (000) 734.02 117.91 108.01 83.45 139.28 120.05 157.98 208.62 405.35 280.69 342.19 893.62 62496.46 181185.64
Sum of Total Operating Expense (000)  $     198,960  $     239,157  $     271,893  $     298,772  $     347,045  $     414,011  $     418,617  $     375,677  $     338,189  $     381,348  $     477,156  $     568,202  $     675,513  $  1,110,860
T1 & T2- Traffic Data  
Sum of RPMs 1.17E+09 1.26E+09 1.42E+09 1.63E+09 1.97E+09 1.98E+09 1.97E+09 1.97E+09 1.99E+09 2.38E+09 3.15E+09 3.84E+09 4.23E+09 3.13E+09
Sum of ASMs 1.83E+09 2.00E+09 2.23E+09 2.51E+09 3.02E+09 3.19E+09 3.23E+09 3.21E+09 3.03E+09 3.66E+09 4.44E+09 5.07E+09 5.50E+09 4.12E+09
Sum of Miles 2.31E+07 2.61E+07 2.80E+07 3.08E+07 3.53E+07 3.61E+07 3.57E+07 3.46E+07 3.04E+07 3.38E+07 4.17E+07 4.89E+07 5.28E+07 3.95E+07
Sum of Depts          33,446          35,678          39,590          41,826          45,824          46,451          45,782          44,248          37,883          38,423          47,465          55,225          55,905          41,700
Sum of Airborne Hours          54,102          59,304          66,503          72,660          82,416          85,400          85,287          82,362          71,098          77,366          94,985        111,143        119,534          85,182
Sum of Block Hours          62,757          69,177          77,174          84,380          97,736        101,027          97,183          92,878          81,145          89,094        108,783        127,416        136,459        105,096
Sum of AC Days            7,235            7,388            8,370            8,915          10,878          11,938          12,547          12,476          10,919          10,425          11,677          13,050          13,523          11,463
Sum of Gallons 5.12E+07 5.61E+07 6.32E+07 7.26E+07 8.07E+07 8.47E+07 8.23E+07 8.14E+07 6.80E+07 7.09E+07 8.34E+07 9.62E+07 1.04E+08 7.67E+07
Sum of Passengers      1,422,405      1,515,953      1,675,633      1,896,606      2,208,196      2,209,568      2,202,652      2,189,711      2,130,669      2,376,304      3,211,717      3,894,069      4,049,994      3,005,711
P12- Profit and Loss Statement  
Sum of Pax Rev (000) -2.05E+05 -2.39E+05 -2.73E+05 -3.12E+05 -3.62E+05 -3.80E+05 -3.47E+05 -3.06E+05 -2.60E+05 -2.79E+05 -3.72E+05 -4.92E+05 -5.27E+05 -4.17E+05
Sum of Charter Pax (000)  $       (3,744)  $       (5,955)  $       (7,142)  $       (5,122)  $       (4,800)  $       (5,971)  $       (7,208)  $     (11,858)  $     (15,534)  $     (18,079)  $     (12,841)  $     (14,495)  $     (13,734)  $     (17,723)
Sum of Transport Related Rev (000)  $       (7,002)  $     (10,443)  $     (14,471)  $     (17,533)  $     (21,418)  $     (17,769)  $     (21,548)  $     (27,106)  $     (29,540)  $     (29,768)  $     (34,922)  $     (38,512)  $    (100,656)  $    (187,160)
Sum of Cargo Rev (000)  $       (2,995)  $       (3,272)  $       (3,574)  $       (3,895)  $       (4,231)  $       (3,852)  $       (2,916)  $       (2,689)  $       (2,521)  $       (2,517)  $       (3,430)  $       (4,339)  $       (4,388)  $       (7,006)
Sum of Total Rev (000) -2.29E+05 -2.71E+05 -3.10E+05 -3.51E+05 -4.06E+05 -4.25E+05 -3.95E+05 -3.59E+05 -3.19E+05 -3.43E+05 -4.39E+05 -5.72E+05 -6.73E+05 -6.53E+05
P52- Functional Grouping Operating Expense Data  
Sum of Pilots And Copilots (000)  $      13,376  $      16,352  $      19,519  $      21,731  $      25,346  $      33,314  $      37,125  $      35,432  $      33,498  $      33,102  $      35,202  $      34,659  $      36,491  $      34,322
Sum of Other Flight Personnel (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           156  $           515  $             -    $             -  
Sum of Trainees And Instructors (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           769  $        1,773  $        2,703  $        2,755
Sum of Personnel Expenses (000)  $           540  $           845  $        1,008  $        1,150  $        1,475  $        1,713  $        2,098  $        1,734  $        1,246  $        1,253  $        1,898  $        3,118  $        3,643  $        2,776
Sum of Employee Benefits And Pensions (000)  $        1,959  $        2,590  $        3,396  $        3,276  $        4,291  $        6,314  $        7,432  $        7,039  $        7,160  $        7,690  $        7,630  $        6,410  $        7,303  $        7,555
Sum of Taxes-Payroll (000)  $        1,365  $        1,404  $        1,389  $        2,128  $        2,305  $        2,635  $        2,678  $        2,775  $        2,616  $        2,628  $        2,924  $        3,250  $        3,427  $        3,210
Sum of Total Flight Equipment Maintenance (Memo) (000)  $      18,851  $      22,343  $      31,387  $      43,124  $      49,188  $      56,239  $      53,656  $      35,605  $      26,750  $      33,538  $      35,283  $      32,805  $      42,518  $      32,465
Sum of Flying Operations-Aircraft Fuels (000)  $      27,650  $      36,291  $      38,913  $      32,265  $      40,538  $      75,217  $      67,222  $      58,003  $      59,539  $      82,469  $     142,736  $     191,130  $     191,621  $     242,538